Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 145392 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 18.0 MiB |
| Average record size in memory | 130.1 B |
Variable types
| Numeric | 9 |
|---|---|
| Categorical | 2 |
| DateTime | 1 |
demand_in_MW is highly overall correlated with hour | High correlation |
dow is highly overall correlated with weekday | High correlation |
doy is highly overall correlated with month and 3 other fields | High correlation |
hour is highly overall correlated with demand_in_MW | High correlation |
month is highly overall correlated with doy and 3 other fields | High correlation |
quarter is highly overall correlated with doy and 3 other fields | High correlation |
season is highly overall correlated with doy and 3 other fields | High correlation |
weekday is highly overall correlated with dow | High correlation |
woy is highly overall correlated with doy and 3 other fields | High correlation |
dow has 20760 (14.3%) zeros | Zeros |
hour has 6058 (4.2%) zeros | Zeros |
weekday has 20760 (14.3%) zeros | Zeros |
Reproduction
| Analysis started | 2024-03-13 11:22:31.753327 |
|---|---|
| Analysis finished | 2024-03-13 11:23:11.854974 |
| Duration | 40.1 seconds |
| Software version | ydata-profiling vv4.6.5 |
| Download configuration | config.json |
demand_in_MW
Real number (ℝ)
HIGH CORRELATION
| Distinct | 28455 |
|---|---|
| Distinct (%) | 19.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32078.925 |
| Minimum | 14544 |
|---|---|
| Maximum | 62009 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.2 MiB |
Quantile statistics
| Minimum | 14544 |
|---|---|
| 5-th percentile | 22622 |
| Q1 | 27571 |
| median | 31420 |
| Q3 | 35647 |
| 95-th percentile | 44187 |
| Maximum | 62009 |
| Range | 47465 |
| Interquartile range (IQR) | 8076 |
Descriptive statistics
| Standard deviation | 6464.2878 |
|---|---|
| Coefficient of variation (CV) | 0.20151199 |
| Kurtosis | 0.73653991 |
| Mean | 32078.925 |
| Median Absolute Deviation (MAD) | 4022 |
| Skewness | 0.73903688 |
| Sum | 4.664019 × 109 |
| Variance | 41787017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 30051 | 24 | < 0.1% |
| 32719 | 22 | < 0.1% |
| 29798 | 22 | < 0.1% |
| 28095 | 21 | < 0.1% |
| 31116 | 21 | < 0.1% |
| 28157 | 21 | < 0.1% |
| 32731 | 21 | < 0.1% |
| 32244 | 21 | < 0.1% |
| 32973 | 20 | < 0.1% |
| 29189 | 20 | < 0.1% |
| Other values (28445) | 145179 |
| Value | Count | Frequency (%) |
| 14544 | 1 | |
| 14586 | 1 | |
| 14821 | 1 | |
| 14955 | 1 | |
| 15390 | 1 | |
| 15526 | 1 | |
| 15919 | 1 | |
| 16688 | 1 | |
| 17422 | 1 | |
| 17734 | 1 |
| Value | Count | Frequency (%) |
| 62009 | 1 | |
| 61909 | 1 | |
| 61796 | 1 | |
| 61770 | 1 | |
| 61646 | 1 | |
| 61643 | 1 | |
| 61641 | 1 | |
| 61610 | 1 | |
| 61608 | 1 | |
| 61532 | 1 |
dow
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9995254 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 20760 |
| Zeros (%) | 14.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.9997128 |
|---|---|
| Coefficient of variation (CV) | 0.66667639 |
| Kurtosis | -1.2496699 |
| Mean | 2.9995254 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.00053393314 |
| Sum | 436107 |
| Variance | 3.9988511 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 2 | 20784 | |
| 3 | 20784 | |
| 1 | 20783 | |
| 4 | 20761 | |
| 5 | 20760 | |
| 6 | 20760 | |
| 0 | 20760 |
| Value | Count | Frequency (%) |
| 0 | 20760 | |
| 1 | 20783 | |
| 2 | 20784 | |
| 3 | 20784 | |
| 4 | 20761 | |
| 5 | 20760 | |
| 6 | 20760 |
| Value | Count | Frequency (%) |
| 6 | 20760 | |
| 5 | 20760 | |
| 4 | 20761 | |
| 3 | 20784 | |
| 2 | 20784 | |
| 1 | 20783 | |
| 0 | 20760 |
doy
Real number (ℝ)
HIGH CORRELATION
| Distinct | 366 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 180.45525 |
| Minimum | 1 |
|---|---|
| Maximum | 366 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 18 |
| Q1 | 90 |
| median | 179 |
| Q3 | 271 |
| 95-th percentile | 347 |
| Maximum | 366 |
| Range | 365 |
| Interquartile range (IQR) | 181 |
Descriptive statistics
| Standard deviation | 105.13873 |
|---|---|
| Coefficient of variation (CV) | 0.5826305 |
| Kurtosis | -1.188963 |
| Mean | 180.45525 |
| Median Absolute Deviation (MAD) | 91 |
| Skewness | 0.036789812 |
| Sum | 26236750 |
| Variance | 11054.153 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 184 | 408 | 0.3% |
| 135 | 408 | 0.3% |
| 137 | 408 | 0.3% |
| 138 | 408 | 0.3% |
| 139 | 408 | 0.3% |
| 140 | 408 | 0.3% |
| 141 | 408 | 0.3% |
| 142 | 408 | 0.3% |
| 143 | 408 | 0.3% |
| 144 | 408 | 0.3% |
| Other values (356) | 141312 |
| Value | Count | Frequency (%) |
| 1 | 407 | |
| 2 | 408 | |
| 3 | 408 | |
| 4 | 408 | |
| 5 | 408 | |
| 6 | 408 | |
| 7 | 408 | |
| 8 | 408 | |
| 9 | 408 | |
| 10 | 408 |
| Value | Count | Frequency (%) |
| 366 | 96 | 0.1% |
| 365 | 384 | |
| 364 | 384 | |
| 363 | 384 | |
| 362 | 384 | |
| 361 | 384 | |
| 360 | 384 | |
| 359 | 384 | |
| 358 | 384 | |
| 357 | 384 |
year
Real number (ℝ)
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2009.8007 |
| Minimum | 2002 |
|---|---|
| Maximum | 2018 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.2 MiB |
Quantile statistics
| Minimum | 2002 |
|---|---|
| 5-th percentile | 2002 |
| Q1 | 2006 |
| median | 2010 |
| Q3 | 2014 |
| 95-th percentile | 2017 |
| Maximum | 2018 |
| Range | 16 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 4.7917397 |
|---|---|
| Coefficient of variation (CV) | 0.0023841865 |
| Kurtosis | -1.1966871 |
| Mean | 2009.8007 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0.008915165 |
| Sum | 2.9220894 × 108 |
| Variance | 22.960769 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) |
| 2004 | 8784 | 6.0% |
| 2008 | 8784 | 6.0% |
| 2012 | 8784 | 6.0% |
| 2016 | 8784 | 6.0% |
| 2010 | 8760 | 6.0% |
| 2017 | 8760 | 6.0% |
| 2005 | 8760 | 6.0% |
| 2006 | 8760 | 6.0% |
| 2007 | 8760 | 6.0% |
| 2009 | 8760 | 6.0% |
| Other values (7) | 57696 |
| Value | Count | Frequency (%) |
| 2002 | 8759 | |
| 2003 | 8760 | |
| 2004 | 8784 | |
| 2005 | 8760 | |
| 2006 | 8760 | |
| 2007 | 8760 | |
| 2008 | 8784 | |
| 2009 | 8760 | |
| 2010 | 8760 | |
| 2011 | 8760 |
| Value | Count | Frequency (%) |
| 2018 | 5137 | |
| 2017 | 8760 | |
| 2016 | 8784 | |
| 2015 | 8760 | |
| 2014 | 8760 | |
| 2013 | 8760 | |
| 2012 | 8784 | |
| 2011 | 8760 | |
| 2010 | 8760 | |
| 2009 | 8760 |
month
Real number (ℝ)
HIGH CORRELATION
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.4358355 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.4389666 |
|---|---|
| Coefficient of variation (CV) | 0.53434657 |
| Kurtosis | -1.1976393 |
| Mean | 6.4358355 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.027390678 |
| Sum | 935719 |
| Variance | 11.826491 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 3 | 12648 | |
| 5 | 12648 | |
| 7 | 12648 | |
| 1 | 12647 | |
| 4 | 12240 | |
| 6 | 12240 | |
| 8 | 11953 | |
| 10 | 11904 | |
| 12 | 11904 | |
| 2 | 11520 | |
| Other values (2) | 23040 |
| Value | Count | Frequency (%) |
| 1 | 12647 | |
| 2 | 11520 | |
| 3 | 12648 | |
| 4 | 12240 | |
| 5 | 12648 | |
| 6 | 12240 | |
| 7 | 12648 | |
| 8 | 11953 | |
| 9 | 11520 | |
| 10 | 11904 |
| Value | Count | Frequency (%) |
| 12 | 11904 | |
| 11 | 11520 | |
| 10 | 11904 | |
| 9 | 11520 | |
| 8 | 11953 | |
| 7 | 12648 | |
| 6 | 12240 | |
| 5 | 12648 | |
| 4 | 12240 | |
| 3 | 12648 |
quarter
Categorical
HIGH CORRELATION
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.2 MiB |
| 2 | |
|---|---|
| 1 | |
| 3 | |
| 4 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 145392 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 37128 | |
| 1 | 36815 | |
| 3 | 36121 | |
| 4 | 35328 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 37128 | |
| 1 | 36815 | |
| 3 | 36121 | |
| 4 | 35328 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 37128 | |
| 1 | 36815 | |
| 3 | 36121 | |
| 4 | 35328 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 145392 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 37128 | |
| 1 | 36815 | |
| 3 | 36121 | |
| 4 | 35328 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 145392 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 37128 | |
| 1 | 36815 | |
| 3 | 36121 | |
| 4 | 35328 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 145392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 37128 | |
| 1 | 36815 | |
| 3 | 36121 | |
| 4 | 35328 |
hour
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.5 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 6058 |
| Zeros (%) | 4.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5.75 |
| median | 11.5 |
| Q3 | 17.25 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 11.5 |
Descriptive statistics
| Standard deviation | 6.9222104 |
|---|---|
| Coefficient of variation (CV) | 0.60193134 |
| Kurtosis | -1.2041741 |
| Mean | 11.5 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0 |
| Sum | 1672008 |
| Variance | 47.916996 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=24)
| Value | Count | Frequency (%) |
| 1 | 6058 | 4.2% |
| 2 | 6058 | 4.2% |
| 23 | 6058 | 4.2% |
| 22 | 6058 | 4.2% |
| 21 | 6058 | 4.2% |
| 20 | 6058 | 4.2% |
| 19 | 6058 | 4.2% |
| 18 | 6058 | 4.2% |
| 17 | 6058 | 4.2% |
| 16 | 6058 | 4.2% |
| Other values (14) | 84812 |
| Value | Count | Frequency (%) |
| 0 | 6058 | |
| 1 | 6058 | |
| 2 | 6058 | |
| 3 | 6058 | |
| 4 | 6058 | |
| 5 | 6058 | |
| 6 | 6058 | |
| 7 | 6058 | |
| 8 | 6058 | |
| 9 | 6058 |
| Value | Count | Frequency (%) |
| 23 | 6058 | |
| 22 | 6058 | |
| 21 | 6058 | |
| 20 | 6058 | |
| 19 | 6058 | |
| 18 | 6058 | |
| 17 | 6058 | |
| 16 | 6058 | |
| 15 | 6058 | |
| 14 | 6058 |
weekday
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9995254 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 20760 |
| Zeros (%) | 14.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.9997128 |
|---|---|
| Coefficient of variation (CV) | 0.66667639 |
| Kurtosis | -1.2496699 |
| Mean | 2.9995254 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.00053393314 |
| Sum | 436107 |
| Variance | 3.9988511 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 2 | 20784 | |
| 3 | 20784 | |
| 1 | 20783 | |
| 4 | 20761 | |
| 5 | 20760 | |
| 6 | 20760 | |
| 0 | 20760 |
| Value | Count | Frequency (%) |
| 0 | 20760 | |
| 1 | 20783 | |
| 2 | 20784 | |
| 3 | 20784 | |
| 4 | 20761 | |
| 5 | 20760 | |
| 6 | 20760 |
| Value | Count | Frequency (%) |
| 6 | 20760 | |
| 5 | 20760 | |
| 4 | 20761 | |
| 3 | 20784 | |
| 2 | 20784 | |
| 1 | 20783 | |
| 0 | 20760 |
woy
Real number (ℝ)
HIGH CORRELATION
| Distinct | 53 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.217935 |
| Minimum | 1 |
|---|---|
| Maximum | 53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 13 |
| median | 26 |
| Q3 | 39 |
| 95-th percentile | 50 |
| Maximum | 53 |
| Range | 52 |
| Interquartile range (IQR) | 26 |
Descriptive statistics
| Standard deviation | 15.019948 |
|---|---|
| Coefficient of variation (CV) | 0.57288827 |
| Kurtosis | -1.1889584 |
| Mean | 26.217935 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 0.037334439 |
| Sum | 3811878 |
| Variance | 225.59882 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 27 | 2856 | 2.0% |
| 30 | 2856 | 2.0% |
| 29 | 2856 | 2.0% |
| 16 | 2856 | 2.0% |
| 4 | 2856 | 2.0% |
| 5 | 2856 | 2.0% |
| 6 | 2856 | 2.0% |
| 7 | 2856 | 2.0% |
| 8 | 2856 | 2.0% |
| 9 | 2856 | 2.0% |
| Other values (43) | 116832 |
| Value | Count | Frequency (%) |
| 1 | 2831 | |
| 2 | 2856 | |
| 3 | 2856 | |
| 4 | 2856 | |
| 5 | 2856 | |
| 6 | 2856 | |
| 7 | 2856 | |
| 8 | 2856 | |
| 9 | 2856 | |
| 10 | 2856 |
| Value | Count | Frequency (%) |
| 53 | 504 | 0.3% |
| 52 | 2688 | |
| 51 | 2688 | |
| 50 | 2688 | |
| 49 | 2688 | |
| 48 | 2688 | |
| 47 | 2688 | |
| 46 | 2688 | |
| 45 | 2688 | |
| 44 | 2688 |
dom
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.722529 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.8013127 |
|---|---|
| Coefficient of variation (CV) | 0.55978987 |
| Kurtosis | -1.1940985 |
| Mean | 15.722529 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.0071063028 |
| Sum | 2285930 |
| Variance | 77.463105 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 2 | 4800 | 3.3% |
| 1 | 4799 | 3.3% |
| 3 | 4777 | 3.3% |
| 28 | 4776 | 3.3% |
| 27 | 4776 | 3.3% |
| 26 | 4776 | 3.3% |
| 25 | 4776 | 3.3% |
| 24 | 4776 | 3.3% |
| 23 | 4776 | 3.3% |
| 22 | 4776 | 3.3% |
| Other values (21) | 97584 |
| Value | Count | Frequency (%) |
| 1 | 4799 | |
| 2 | 4800 | |
| 3 | 4777 | |
| 4 | 4776 | |
| 5 | 4776 | |
| 6 | 4776 | |
| 7 | 4776 | |
| 8 | 4776 | |
| 9 | 4776 | |
| 10 | 4776 |
| Value | Count | Frequency (%) |
| 31 | 2784 | |
| 30 | 4368 | |
| 29 | 4464 | |
| 28 | 4776 | |
| 27 | 4776 | |
| 26 | 4776 | |
| 25 | 4776 | |
| 24 | 4776 | |
| 23 | 4776 | |
| 22 | 4776 |
date
Date
| Distinct | 6059 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.2 MiB |
| Minimum | 2002-01-01 00:00:00 |
|---|---|
| Maximum | 2018-08-03 00:00:00 |
Histogram with fixed size bins (bins=50)
season
Categorical
HIGH CORRELATION
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.2 MiB |
| 2 | |
|---|---|
| 3 | |
| 1 | |
| 4 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 145392 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 37536 | |
| 3 | 36841 | |
| 1 | 36071 | |
| 4 | 34944 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 37536 | |
| 3 | 36841 | |
| 1 | 36071 | |
| 4 | 34944 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 37536 | |
| 3 | 36841 | |
| 1 | 36071 | |
| 4 | 34944 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 145392 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 37536 | |
| 3 | 36841 | |
| 1 | 36071 | |
| 4 | 34944 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 145392 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 37536 | |
| 3 | 36841 | |
| 1 | 36071 | |
| 4 | 34944 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 145392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 37536 | |
| 3 | 36841 | |
| 1 | 36071 | |
| 4 | 34944 |
| demand_in_MW | dom | dow | doy | hour | month | quarter | season | weekday | woy | year | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| demand_in_MW | 1.000 | -0.001 | -0.194 | -0.064 | 0.514 | -0.064 | 0.249 | 0.308 | -0.194 | -0.065 | -0.068 |
| dom | -0.001 | 1.000 | -0.001 | 0.094 | -0.000 | 0.010 | 0.014 | 0.014 | -0.001 | 0.068 | -0.001 |
| dow | -0.194 | -0.001 | 1.000 | -0.000 | -0.000 | -0.000 | 0.000 | 0.000 | 1.000 | -0.001 | -0.000 |
| doy | -0.064 | 0.094 | -0.000 | 1.000 | -0.000 | 0.997 | 0.925 | 0.903 | -0.000 | 0.973 | -0.042 |
| hour | 0.514 | -0.000 | -0.000 | -0.000 | 1.000 | -0.000 | 0.000 | 0.000 | -0.000 | -0.000 | -0.000 |
| month | -0.064 | 0.010 | -0.000 | 0.997 | -0.000 | 1.000 | 1.000 | 0.943 | -0.000 | 0.971 | -0.042 |
| quarter | 0.249 | 0.014 | 0.000 | 0.925 | 0.000 | 1.000 | 1.000 | 0.639 | -0.000 | 0.947 | -0.041 |
| season | 0.308 | 0.014 | 0.000 | 0.903 | 0.000 | 0.943 | 0.639 | 1.000 | 0.001 | 0.588 | -0.026 |
| weekday | -0.194 | -0.001 | 1.000 | -0.000 | -0.000 | -0.000 | -0.000 | 0.001 | 1.000 | -0.001 | -0.000 |
| woy | -0.065 | 0.068 | -0.001 | 0.973 | -0.000 | 0.971 | 0.947 | 0.588 | -0.001 | 1.000 | -0.041 |
| year | -0.068 | -0.001 | -0.000 | -0.042 | -0.000 | -0.042 | -0.041 | -0.026 | -0.000 | -0.041 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| demand_in_MW | dow | doy | year | month | quarter | hour | weekday | woy | dom | date | season | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002-01-01 01:00:00 | 30393.0 | 1 | 1 | 2002 | 1 | 1 | 1 | 1 | 1 | 1 | 2002-01-01 | 1 |
| 2002-01-01 02:00:00 | 29265.0 | 1 | 1 | 2002 | 1 | 1 | 2 | 1 | 1 | 1 | 2002-01-01 | 1 |
| 2002-01-01 03:00:00 | 28357.0 | 1 | 1 | 2002 | 1 | 1 | 3 | 1 | 1 | 1 | 2002-01-01 | 1 |
| 2002-01-01 04:00:00 | 27899.0 | 1 | 1 | 2002 | 1 | 1 | 4 | 1 | 1 | 1 | 2002-01-01 | 1 |
| 2002-01-01 05:00:00 | 28057.0 | 1 | 1 | 2002 | 1 | 1 | 5 | 1 | 1 | 1 | 2002-01-01 | 1 |
| 2002-01-01 06:00:00 | 28654.0 | 1 | 1 | 2002 | 1 | 1 | 6 | 1 | 1 | 1 | 2002-01-01 | 1 |
| 2002-01-01 07:00:00 | 29308.0 | 1 | 1 | 2002 | 1 | 1 | 7 | 1 | 1 | 1 | 2002-01-01 | 1 |
| 2002-01-01 08:00:00 | 29595.0 | 1 | 1 | 2002 | 1 | 1 | 8 | 1 | 1 | 1 | 2002-01-01 | 1 |
| 2002-01-01 09:00:00 | 29943.0 | 1 | 1 | 2002 | 1 | 1 | 9 | 1 | 1 | 1 | 2002-01-01 | 1 |
| 2002-01-01 10:00:00 | 30692.0 | 1 | 1 | 2002 | 1 | 1 | 10 | 1 | 1 | 1 | 2002-01-01 | 1 |
| demand_in_MW | dow | doy | year | month | quarter | hour | weekday | woy | dom | date | season | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2018-08-02 15:00:00 | 47154.0 | 3 | 214 | 2018 | 8 | 3 | 15 | 3 | 31 | 2 | 2018-08-02 | 3 |
| 2018-08-02 16:00:00 | 46989.0 | 3 | 214 | 2018 | 8 | 3 | 16 | 3 | 31 | 2 | 2018-08-02 | 3 |
| 2018-08-02 17:00:00 | 46816.0 | 3 | 214 | 2018 | 8 | 3 | 17 | 3 | 31 | 2 | 2018-08-02 | 3 |
| 2018-08-02 18:00:00 | 46760.0 | 3 | 214 | 2018 | 8 | 3 | 18 | 3 | 31 | 2 | 2018-08-02 | 3 |
| 2018-08-02 19:00:00 | 45641.0 | 3 | 214 | 2018 | 8 | 3 | 19 | 3 | 31 | 2 | 2018-08-02 | 3 |
| 2018-08-02 20:00:00 | 44057.0 | 3 | 214 | 2018 | 8 | 3 | 20 | 3 | 31 | 2 | 2018-08-02 | 3 |
| 2018-08-02 21:00:00 | 43256.0 | 3 | 214 | 2018 | 8 | 3 | 21 | 3 | 31 | 2 | 2018-08-02 | 3 |
| 2018-08-02 22:00:00 | 41552.0 | 3 | 214 | 2018 | 8 | 3 | 22 | 3 | 31 | 2 | 2018-08-02 | 3 |
| 2018-08-02 23:00:00 | 38500.0 | 3 | 214 | 2018 | 8 | 3 | 23 | 3 | 31 | 2 | 2018-08-02 | 3 |
| 2018-08-03 00:00:00 | 35486.0 | 4 | 215 | 2018 | 8 | 3 | 0 | 4 | 31 | 3 | 2018-08-03 | 3 |